Breakthrough Improvement with QI Macros and Excel: Finding the Invisible Low-Hanging Fruit by Jay Arthur

Author:Jay Arthur [Arthur, Jay]
Language: eng
Format: azw3
Publisher: McGraw-Hill Education
Published: 2014-03-11T04:00:00+00:00

Using Statistical Tools

Manufacturing companies get into more detailed analysis of data to determine the variation. ANOVA (or analysis of variance) seeks to understand how data is distributed around a mean or average. You can use any of the statistical analysis tools of Excel through the QI Macros. To perform ANOVA in native Excel, you must have Excel’s “Data Analysis Toolpak” installed. Go to Excel “Options–Add-Ins–Manage Excel Add-Ins Go” and check “Analysis Toolpak” (Fig. 8.23), and Excel will either turn these tools on or ask you to install them using your Office or Excel CDs. To check if they have been installed, click on “Tools–Data Analysis.” If you cannot see “Data Analysis” in the Tools menu, the statistical analysis tools are not installed.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.